CREATE TABLE [dbo].[TREMPR_GRUP]
(
[CO_GRUP] [dbo].[TD_VC_008] NOT NULL,
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TREMPR_GR__CO_US__690797E6] DEFAULT (substring(suser_sname(),(1),(8))),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TREMPR_GR__FE_US__69FBBC1F] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NULL CONSTRAINT [DF__TREMPR_GR__CO_US__6AEFE058] DEFAULT (substring(suser_sname(),(1),(8))),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NULL CONSTRAINT [DF__TREMPR_GR__FE_US__6BE40491] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TREMPR_GRUP] ADD CONSTRAINT [PK__TREMPR_G__AD873DE922951AFD] PRIMARY KEY CLUSTERED  ([CO_GRUP], [CO_EMPR]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TREMPR_GRUP] ADD CONSTRAINT [FK__TREMPR_GR__CO_EM__42CCE065] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMEMPR] ([CO_EMPR])
GO
ALTER TABLE [dbo].[TREMPR_GRUP] ADD CONSTRAINT [FK__TREMPR_GR__CO_GR__43C1049E] FOREIGN KEY ([CO_GRUP]) REFERENCES [dbo].[TMGRUP_USUA] ([CO_GRUP])
GO
GRANT SELECT ON  [dbo].[TREMPR_GRUP] TO [public]
GRANT INSERT ON  [dbo].[TREMPR_GRUP] TO [public]
GRANT DELETE ON  [dbo].[TREMPR_GRUP] TO [public]
GRANT UPDATE ON  [dbo].[TREMPR_GRUP] TO [public]
GO
